package com.youhome.mapper;

import com.youhome.model.Zip;
import com.youhome.result.AssociateCity;
import com.youhome.result.AssociateZip;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ZipMapper {
    int deleteByPrimaryKey(String zipcode);

    int insert(Zip record);

    int insertSelective(Zip record);

    Zip selectByPrimaryKey(String zipcode);

    List<String> selectZipsByCity(String city);

    int updateByPrimaryKeySelective(Zip record);

    int updateByPrimaryKeyWithBLOBs(Zip record);

    int updateByPrimaryKey(Zip record);

    List<Zip> selectByLikeZipCode(String zipCode);

    List<Zip> selectByLikeCity(String city);

    List<AssociateZip> selectAssociateByLikeZip(String zip);

    List<AssociateCity> selectAssociateByLikeCity(String city);
}